/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50624
Source Host           : localhost:3306
Source Database       : wxauth

Target Server Type    : MYSQL
Target Server Version : 50624
File Encoding         : 65001

Date: 2019-05-10 17:28:56
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `oauth_authorization_code`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_authorization_code`;
CREATE TABLE `oauth_authorization_code` (
`authorization_code`  varchar(32) NOT NULL DEFAULT '' COMMENT '临时凭证' ,
`user_id`  varchar(32) NULL DEFAULT NULL COMMENT '用户id' ,
`client_id`  varchar(32) NULL DEFAULT NULL COMMENT '客户端id' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`expire_time`  datetime NULL DEFAULT NULL COMMENT '过期时间' ,
PRIMARY KEY (`authorization_code`),
INDEX `idx_auth_authorization_code_expire_time` (`expire_time`) USING BTREE 
)
ENGINE=InnoDB

;

-- ----------------------------
-- Records of oauth_authorization_code
-- ----------------------------
BEGIN;
INSERT INTO `oauth_authorization_code` VALUES ('28acc20a48e4f8695ed876ef8334e971', '0000000000000000000000000000000', 'authServer', '2018-09-27 16:52:15', '2018-09-27 16:57:15'), ('6b9849680862780b83f2bfa42ed6e938', '0000000000000000000000000000000', 'authServer', '2018-09-27 16:43:57', '2018-09-27 16:48:57');
COMMIT;

-- ----------------------------
-- Table structure for `oauth_client`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client`;
CREATE TABLE `oauth_client` (
`client_id`  varchar(32) NOT NULL ,
`resource_ids`  varchar(256) NULL DEFAULT NULL ,
`client_secret`  varchar(256) NULL DEFAULT NULL ,
`client_name`  varchar(256) NULL DEFAULT NULL ,
`scope`  varchar(2048) NULL DEFAULT NULL COMMENT '授权领域（客户端）' ,
`authorized_grant_types`  varchar(256) NULL DEFAULT NULL COMMENT '授权类型' ,
`client_type`  int(11) NULL DEFAULT 1 COMMENT '客户端类型，0:系统应用，1：子应用，2：第三方应用' ,
`client_status`  int(11) NULL DEFAULT 100 COMMENT '客户端状态' ,
`web_home_url`  varchar(256) NULL DEFAULT NULL COMMENT '应用首页' ,
`web_server_redirect_uri`  varchar(256) NULL DEFAULT NULL ,
`authorities`  varchar(256) NULL DEFAULT NULL ,
`access_token_validity`  int(11) NULL DEFAULT 0 ,
`refresh_token_validity`  int(11) NULL DEFAULT 0 ,
`additional_information`  varchar(4096) NULL DEFAULT NULL ,
`auto_approve`  varchar(8) NULL DEFAULT NULL COMMENT '是否自动接受授权' ,
`order_value`  int(11) NULL DEFAULT NULL COMMENT '排序字段，越小越前' ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`client_id`)
)
ENGINE=InnoDB
COMMENT='认证应用'

;

-- ----------------------------
-- Records of oauth_client
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client` VALUES ('313edfaffb9d40f880895a974b9b80a7', null, '11111111111', '计划任务系统', null, 'authorization_code,implicit,password', '1', '100', 'http://', null, null, null, null, null, 'false', '100', '2018-09-29 15:49:50', '2018-09-29 15:49:50'), ('6aeea4ac0a114e9f905a2974d97b2e91', null, '111111', '伍邪微框架UI', null, 'authorization_code,implicit,password,refresh_token', '1', '100', 'http://', null, null, null, null, null, 'false', '100', '2018-09-19 17:23:19', '2018-09-29 10:32:57'), ('authServer', null, 'authServer', '认证应用', null, 'password,refresh_token,authorization_code,implicit', '0', '100', 'http://localhost:8080', null, null, '0', '0', null, 'true', '1', null, '2018-09-12 11:26:10');
COMMIT;

-- ----------------------------
-- Table structure for `oauth_refresh_token`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE `oauth_refresh_token` (
`refresh_token`  varchar(32) NOT NULL DEFAULT '' COMMENT '刷新令牌' ,
`token`  varchar(32) NULL DEFAULT NULL COMMENT '令牌' ,
`user_id`  varchar(32) NULL DEFAULT NULL COMMENT '用户id' ,
`client_id`  varchar(32) NULL DEFAULT NULL COMMENT '客户端id' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`expire_time`  datetime NULL DEFAULT NULL COMMENT '过期时间' ,
PRIMARY KEY (`refresh_token`),
INDEX `idx_auth_refresh_token_expire_time` (`expire_time`) USING BTREE 
)
ENGINE=InnoDB

;

-- ----------------------------
-- Records of oauth_refresh_token
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `oauth_resource`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_resource`;
CREATE TABLE `oauth_resource` (
`resource_id`  varchar(32) NOT NULL DEFAULT '' ,
`parent_id`  varchar(32) NULL DEFAULT NULL ,
`client_id`  varchar(32) NOT NULL DEFAULT '' ,
`resource_name`  varchar(64) NULL DEFAULT NULL ,
`url`  varchar(256) NULL DEFAULT NULL COMMENT '资源地址' ,
`permission`  varchar(64) NULL DEFAULT NULL COMMENT '权限标识' ,
`order_value`  int(11) NULL DEFAULT 100 COMMENT '排序，越小越前' ,
`resource_type`  int(11) NULL DEFAULT NULL COMMENT '资源类型，0菜单，1操作' ,
`operator_name`  varchar(64) NULL DEFAULT NULL ,
`operator_id`  varchar(32) NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`resource_id`, `client_id`)
)
ENGINE=InnoDB
COMMENT='资源信息'

;

-- ----------------------------
-- Records of oauth_resource
-- ----------------------------
BEGIN;
INSERT INTO `oauth_resource` VALUES ('10', '', '313edfaffb9d40f880895a974b9b80a7', '任务管理', null, null, '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 15:50:51', '2018-09-29 15:50:51'), ('10', '', '6aeea4ac0a114e9f905a2974d97b2e91', '系统设置', null, null, '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 14:53:40', '2018-09-29 14:53:40'), ('10', null, 'authServer', '系统设置', null, null, '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-12 15:14:07', '2018-09-29 16:06:54'), ('1001', '10', '6aeea4ac0a114e9f905a2974d97b2e91', '用户管理', null, null, '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:37:57', '2018-09-29 16:37:57'), ('1001', '10', 'authServer', '应用管理', '/api/OauthClient/list', 'client:list', '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-12 15:14:07', '2018-09-29 11:11:12'), ('100101', '1001', 'authServer', '增加', '/api/OauthClient/add', 'client:add', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 10:39:46', '2018-09-29 14:41:19'), ('100102', '1001', 'authServer', '删除', '/api/OauthClient/delete', 'client:delete', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 10:40:50', '2018-09-29 11:11:20'), ('100103', '1001', 'authServer', '修改', '/api/OauthClient/update', 'client:update', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 10:45:20', '2018-09-29 11:11:24'), ('1002', '10', '6aeea4ac0a114e9f905a2974d97b2e91', '角色管理', null, null, '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:38:19', '2018-09-29 16:38:19'), ('1002', '10', 'authServer', '系统资源管理', '/api/OauthResource/list', 'resource:list', '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 10:36:04', '2018-09-29 11:12:56'), ('100201', '1002', 'authServer', '增加', '/api/OauthResource/add', 'resource:add', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:12:32', '2018-09-29 11:12:32'), ('100202', '1002', 'authServer', '删除', null, 'resource:delete', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:13:52', '2018-09-29 11:13:52'), ('100203', '1002', 'authServer', '修改', null, 'resource:update', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:14:13', '2018-09-29 11:14:13'), ('1003', '10', '6aeea4ac0a114e9f905a2974d97b2e91', '应用管理', null, null, '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:38:35', '2018-09-29 16:38:35'), ('1003', '10', 'authServer', '用户角色管理', '/api/OauthRole/list', 'role:list', '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 10:37:02', '2018-09-29 11:15:34'), ('100301', '1003', 'authServer', '增加', null, 'role:add', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:15:48', '2018-09-29 11:15:48'), ('100302', '1003', 'authServer', '删除', null, 'role:delete', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:15:59', '2018-09-29 11:16:38'), ('100303', '1003', 'authServer', '修改', null, 'role:update', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:16:22', '2018-09-29 11:16:35'), ('1004', '10', '6aeea4ac0a114e9f905a2974d97b2e91', '应用资源', null, null, '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:38:52', '2018-09-29 16:38:52'), ('1004', '10', 'authServer', '用户管理', '/api/OauthUser/list', 'user:list', '100', '0', '伍邪', '0000000000000000000000000000000', '2018-09-29 10:37:19', '2018-09-29 11:17:18'), ('100401', '1004', 'authServer', '增加', null, 'user:add', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:17:32', '2018-09-29 11:17:32'), ('100402', '1004', 'authServer', '删除', null, 'user:delete', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:17:51', '2018-09-29 11:18:11'), ('100403', '1004', 'authServer', '修改', null, 'user:update', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:18:07', '2018-09-29 11:18:07'), ('11', null, 'authServer', '认证资源', null, null, '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:39:47', '2018-09-29 11:39:47'), ('1101', '11', 'authServer', '认证用户信息', '/client/userinfo', 'client:userinfo', '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:40:41', '2018-09-29 11:40:41'), ('1102', '11', 'authServer', '认证用户登出', '/client/logout', null, '101', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:41:26', '2018-09-29 15:59:02'), ('1103', '11', 'authServer', '用户资源信息', null, null, '100', '1', '伍邪', '0000000000000000000000000000000', '2018-09-29 11:49:30', '2018-09-29 11:49:30');
COMMIT;

-- ----------------------------
-- Table structure for `oauth_role`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_role`;
CREATE TABLE `oauth_role` (
`role_id`  varchar(32) NOT NULL DEFAULT '' ,
`role_name`  varchar(64) NULL DEFAULT NULL ,
`role_description`  varchar(500) NULL DEFAULT NULL ,
`operator_id`  varchar(32) NULL DEFAULT NULL ,
`operator_name`  varchar(64) NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`role_id`)
)
ENGINE=InnoDB

;

-- ----------------------------
-- Records of oauth_role
-- ----------------------------
BEGIN;
INSERT INTO `oauth_role` VALUES ('3571b34adad94c07888e5b84341fa862', '应用管理员', '', '0000000000000000000000000000000', '伍邪', '2018-09-21 15:20:31', '2018-09-29 12:10:53'), ('496efc2f219d46f0935de14c46efacc1', '办公室主任', '', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-05 17:33:36', '2018-09-21 15:19:39'), ('5458f4113c344c74a80ab4a57815c6f0', '超级管理员', '系统默认管理员', '0000000000000000000000000000000', '0000000000000000000000000000000', null, '2018-09-05 17:05:41');
COMMIT;

-- ----------------------------
-- Table structure for `oauth_role_resource`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_role_resource`;
CREATE TABLE `oauth_role_resource` (
`serial_id`  varchar(32) NOT NULL DEFAULT '' ,
`role_id`  varchar(32) NULL DEFAULT NULL ,
`client_id`  varchar(32) NULL DEFAULT NULL COMMENT '资源所属应用' ,
`resource_id`  varchar(32) NULL DEFAULT NULL ,
`operator_name`  varchar(64) NULL DEFAULT NULL COMMENT '操作人' ,
`operator_id`  varchar(32) NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`serial_id`)
)
ENGINE=InnoDB
COMMENT='角色资源信息'

;

-- ----------------------------
-- Records of oauth_role_resource
-- ----------------------------
BEGIN;
INSERT INTO `oauth_role_resource` VALUES ('07a863c0865f4e2789fd29e056b9616b', '496efc2f219d46f0935de14c46efacc1', 'authServer', '1003', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('0c10636ed7ec4452a97e8e95e259493f', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100302', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('1477403df80d41cb9704ed5bb92018eb', '3571b34adad94c07888e5b84341fa862', 'authServer', '1102', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('15224b6181dc40d1a37755219c3b1d56', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('15c8f888c2654b1eada0310ddd6882bc', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('1e376ce286614aeb891097ef64d802df', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('20ba1a489c06452182d919e369d2857d', '496efc2f219d46f0935de14c46efacc1', 'authServer', '1103', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('22d49ddc35ae4e84bc7f81387b5538bc', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100202', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('23199b1d6410459d8b3f969aafa91f98', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100403', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('2675774da11f4a4bbd0626a79be0a6ac', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('2d0792c9549d43d489c00c07b89a7a10', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('30a973e92d424d77b8202582a95dc76f', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '1002', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('31f37af1ef364ec59e84e9d4d8048806', '496efc2f219d46f0935de14c46efacc1', 'authServer', '1004', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('35219c51ae1e4a30bacfd419e924ec13', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('35560ee733a74dbab04ecce008211d45', '3571b34adad94c07888e5b84341fa862', 'authServer', '100101', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('36e1a8e31d114c16b77581c0ac6a224d', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('382ece5d11794aa5a8221d83c67d9590', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('389d2eca30974ea7a2d4c18e6dbbabaf', '496efc2f219d46f0935de14c46efacc1', 'authServer', '1101', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('3e9a0e2927db45e389a04442a16eb369', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('3ea704fc055a46a9bdf9105452f6b156', '496efc2f219d46f0935de14c46efacc1', 'authServer', '100403', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('3f7a7582177c4fa987a94b5afbc91335', '496efc2f219d46f0935de14c46efacc1', 'authServer', '100401', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('453b775b6f69412594250be49363c27d', '5458f4113c344c74a80ab4a57815c6f0', '6aeea4ac0a114e9f905a2974d97b2e91', '1001', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:42:22', '2018-09-29 16:42:22'), ('46f30f5c85814008a551b786ff621704', '3571b34adad94c07888e5b84341fa862', 'authServer', '1103', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('4ee9ed1271bd4c14b4585fc64f216a3b', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('52ff7b2656e84a218208057855ae3bfe', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100303', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('53848a8ccda945c9ae4f69bc0ecd5e45', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('565309ac03644d3ca50a57d021ddd6ca', '5458f4113c344c74a80ab4a57815c6f0', '6aeea4ac0a114e9f905a2974d97b2e91', '1002', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:42:22', '2018-09-29 16:42:22'), ('5829d9e50499407ca4e29775d75b341e', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('584eb6c8506a4c75956cba77f3dc06cd', '5458f4113c344c74a80ab4a57815c6f0', '6aeea4ac0a114e9f905a2974d97b2e91', '10', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:42:22', '2018-09-29 16:42:22'), ('5897b7fee4b9491da1bed46c403b1e26', '3571b34adad94c07888e5b84341fa862', 'authServer', '100201', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('59482033330049abbeb48c4191722da4', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('59f90e7765ef40708e6f8222ed2d57e5', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('5f4720557a514b21881b13be595253ed', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('61224c4cb9bc422caed947817d0d2b75', '3571b34adad94c07888e5b84341fa862', 'authServer', '1101', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('67714e018aaf4184a76f97dff9d3562e', '496efc2f219d46f0935de14c46efacc1', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('7255bf38312843879f2fa7c78288178d', '3571b34adad94c07888e5b84341fa862', 'authServer', '100202', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('7810800130dc40419a5acb0e4c0470c5', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100301', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('78a47017fa2f447e93898ffa97314688', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('7bbfd12b39d14f22974f4bf582ebf689', '496efc2f219d46f0935de14c46efacc1', 'authServer', '11', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('7d71c607c17e4aa4b10b55fa00aa544e', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('7f765c0fdb79404894313e6123c8ba6a', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '1103', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('87b4feaefb2c40f7a9e1d3960c8ca257', '3571b34adad94c07888e5b84341fa862', 'authServer', '1002', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('88b7a8cbf94e4d03ba13aefe0f4f5ff9', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('89496d56c10b46b5a0ce91feefc111f7', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('8bb7851147aa486484386c4a96ee86d3', '3571b34adad94c07888e5b84341fa862', 'authServer', '1001', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('8bd6e70f5ca04d1a988b4b84d18b8fc1', '5458f4113c344c74a80ab4a57815c6f0', '6aeea4ac0a114e9f905a2974d97b2e91', '1004', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:42:22', '2018-09-29 16:42:22'), ('8df18a9592d8426d899100b2f8c625f9', '496efc2f219d46f0935de14c46efacc1', 'authServer', '100302', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('91278b2c427a44c78bdba7c5f343241d', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '11', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('914a6399d2f74961a05c5e80faa4396d', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '1004', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('92600a2ec14241989f02179bd063484f', '496efc2f219d46f0935de14c46efacc1', 'authServer', '100303', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('93abfae251ea4330a88265139090f62f', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('93c144afcb7040c8aeb2a1cf9265f382', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('9486c70d9251478192b2c2983095f854', '3571b34adad94c07888e5b84341fa862', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('9528292072e94dd7bbc28ec1693f2742', '3571b34adad94c07888e5b84341fa862', 'authServer', '100103', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('9934af873beb4c07890e68ab2d4cae66', '3571b34adad94c07888e5b84341fa862', 'authServer', '100102', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('9e24551642074bd8af7a4c855d514eb3', '3571b34adad94c07888e5b84341fa862', '6aeea4ac0a114e9f905a2974d97b2e91', '10', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:56:51', '2018-09-29 16:56:51'), ('9e67dfabbcb34247a277b9897c26e37f', '496efc2f219d46f0935de14c46efacc1', 'authServer', '1102', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('a1c1b1abc15c4a2e90d19e2bfca96607', '496efc2f219d46f0935de14c46efacc1', 'authServer', '100301', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('a5b72f616af84b5482823b575f2ee258', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100201', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('a6c0fa7b1b4340ec92e2a1f9f6b45b19', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('b24f263045f1484281bc08b8e8ae56fa', '3571b34adad94c07888e5b84341fa862', 'authServer', '100203', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('b68fbf67a22d40f1bfc1db700b063522', '3571b34adad94c07888e5b84341fa862', '6aeea4ac0a114e9f905a2974d97b2e91', '1004', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:56:51', '2018-09-29 16:56:51'), ('b95da5dba7734193891644efe07dc8a0', '496efc2f219d46f0935de14c46efacc1', 'authServer', '100402', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:22', '2018-10-16 15:52:22'), ('bade07d9860a49c7a9ff79329368a5ea', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '1003', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('bd7fd7ddceba4c798cb6b89f3d9b8283', '3571b34adad94c07888e5b84341fa862', 'authServer', '11', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:52:33', '2018-10-16 15:52:33'), ('be11cd4b365b457cb3e3ebb9d04a18e7', '496efc2f219d46f0935de14c46efacc1', '6aeea4ac0a114e9f905a2974d97b2e91', '10', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:57:20', '2018-09-29 16:57:20'), ('be63ddccb58d4255aa0bee53f2753d75', '5458f4113c344c74a80ab4a57815c6f0', '313edfaffb9d40f880895a974b9b80a7', '10', '伍邪', '0000000000000000000000000000000', '2018-10-08 11:39:12', '2018-10-08 11:39:12'), ('bf02f1eda8dc4bbe8fa5c7e38b735177', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100203', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('c4d858b6790c430b9acf2156a0988ccb', '496efc2f219d46f0935de14c46efacc1', '6aeea4ac0a114e9f905a2974d97b2e91', '10', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:57:20', '2018-09-29 16:57:20'), ('c5fa13b2a7cf4867b3962e2a6a6ea31a', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '1101', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('cb1493fb53eb4158851e1674b1a42ed8', '3571b34adad94c07888e5b84341fa862', '6aeea4ac0a114e9f905a2974d97b2e91', '1003', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:56:51', '2018-09-29 16:56:51'), ('dd257632cce84328b2aca3f0ed2d259b', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('dd7f594561d14842884942e343f91a98', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '1102', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('e1cc91a946d5460b899cbe2d72ec7cef', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100402', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('e5217bf0936b442eb6d0e67db55896ce', '3571b34adad94c07888e5b84341fa862', '6aeea4ac0a114e9f905a2974d97b2e91', '10', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:56:51', '2018-09-29 16:56:51'), ('e5a5f9a1cd214cb089eda0f0cc0c5417', '496efc2f219d46f0935de14c46efacc1', '6aeea4ac0a114e9f905a2974d97b2e91', '1002', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:57:20', '2018-09-29 16:57:20'), ('e9069513ca264649a3b7e76e11934f80', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('f4b581b399af4c69a91655403a7acf35', '5458f4113c344c74a80ab4a57815c6f0', '6aeea4ac0a114e9f905a2974d97b2e91', '1003', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:42:22', '2018-09-29 16:42:22'), ('f5684a1dc8ec4fe0be1238b8c0e54adb', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '100401', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('f8bccfa704c543958b4d92070f790af0', '496efc2f219d46f0935de14c46efacc1', '6aeea4ac0a114e9f905a2974d97b2e91', '1001', '伍邪', '0000000000000000000000000000000', '2018-09-29 16:57:20', '2018-09-29 16:57:20'), ('f9659b26fad74083b54126b6382f2496', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21'), ('f9f0f5bd99e3402cb1a40ce0b85f1de8', '5458f4113c344c74a80ab4a57815c6f0', 'authServer', '10', '伍邪', '0000000000000000000000000000000', '2018-10-16 15:45:21', '2018-10-16 15:45:21');
COMMIT;

-- ----------------------------
-- Table structure for `oauth_token`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_token`;
CREATE TABLE `oauth_token` (
`token`  varchar(32) NOT NULL DEFAULT '' COMMENT '令牌' ,
`user_id`  varchar(32) NULL DEFAULT NULL COMMENT '用户id' ,
`account`  varchar(32) NULL DEFAULT NULL ,
`user_name`  varchar(64) NULL DEFAULT NULL ,
`client_id`  varchar(32) NULL DEFAULT NULL COMMENT '客户端id' ,
`client_name`  varchar(256) NULL DEFAULT NULL COMMENT '客户端名称' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`expire_time`  datetime NULL DEFAULT NULL COMMENT '过期时间' ,
`refresh_token`  varchar(32) NULL DEFAULT NULL COMMENT '刷新令牌' ,
PRIMARY KEY (`token`),
INDEX `idx_auth_token_expire_time` (`expire_time`) USING BTREE 
)
ENGINE=InnoDB

;

-- ----------------------------
-- Records of oauth_token
-- ----------------------------
BEGIN;
INSERT INTO `oauth_token` VALUES ('01acf40fd302c9c5c0aa47d4e43e67af', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-11 09:29:20', '2019-04-11 21:29:20', null), ('0400ae8a6920eb6366d851679956c543', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-16 11:56:50', '2018-10-16 23:56:50', null), ('06fd31afd8516dd76da1559409151d6c', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 15:38:28', '2019-03-22 03:38:28', null), ('106b6a54be46a5bb272d1e287822c38f', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 16:22:43', '2019-03-22 04:22:43', null), ('166b014088d2200a47bd8a2eae0589e4', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-14 22:20:03', '2018-12-15 10:20:03', null), ('17260860de367e9d55adf07788233af8', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-08 10:17:03', '2018-10-08 22:17:03', null), ('17348ff8d3d8def76bd62b746ac77f81', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-12 20:54:47', '2018-12-13 08:54:47', null), ('174e9f855ce51d6ccea8133f43982525', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-18 10:32:12', '2018-12-18 22:32:12', null), ('205fe4e63c77d1b398d6459711794587', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-25 09:12:41', '2018-12-25 21:12:41', null), ('23162fc95aedfd9beae7a9bc5e841f77', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-09-28 14:58:19', '2018-09-29 02:58:19', null), ('262fe010d3993bfe7bb3732db81b6d89', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-16 16:38:39', '2019-04-17 04:38:39', null), ('2a37567f95f738aeb1c5bf3810cacd4c', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-09-29 15:40:56', '2018-09-30 03:40:56', null), ('2efdfa6638685f2893966946fc1293c6', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-21 10:21:34', '2018-12-21 22:21:34', null), ('35860a2d275a4c20fe580c6bfdb45aac', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-11 17:51:34', '2018-10-12 05:51:34', null), ('3bff0eef5430123ebb705a153c4c64e4', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-17 10:04:37', '2018-10-17 22:04:37', null), ('3e1ba27fc86dab4231a2f04f8b2b286a', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-17 22:02:21', '2018-12-18 10:02:21', null), ('3f2cf832362b9516e216b99bb1bd6e09', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-11 16:40:12', '2019-04-12 04:40:12', null), ('4231581e03a8e6520cff05a5ab240894', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 14:06:33', '2019-03-22 02:06:34', null), ('44923cfe050bfc55a37e3b43f5f5dd88', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-08 15:12:47', '2018-10-09 03:12:47', null), ('4550246241240592c4eddf3d012b414b', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-01-09 11:59:19', '2019-01-09 23:59:19', null), ('45f9c0ee3edc5a3a241b97af7a6dea98', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-24 09:22:15', '2018-12-24 21:22:15', null), ('4763ea45ab1ff27347e6164a9b22bde4', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-09-29 10:22:16', '2018-09-29 22:22:16', null), ('4917fba3a3fc22be5d9a589cbe31c3c5', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-22 16:36:49', '2019-03-23 04:36:49', null), ('4a91a87a0825edcff015271b284d9763', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 14:23:55', '2019-03-22 02:23:55', null), ('4c9fb83b5d1539f56932879c6448a7a7', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-24 14:51:58', '2018-10-25 02:51:58', null), ('4e7eebf51fbc6a3db0a22c25f96dcd66', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-29 09:28:28', '2018-12-29 21:28:28', null), ('4ef136dff021da29dc20dd5d0b294317', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-10 09:32:45', '2019-04-10 21:32:45', null), ('524c81e2be45ec804966ea16a3465178', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-08 11:36:58', '2018-10-08 23:36:58', null), ('530a61aa57cae0d2aeff3beda2749ec1', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-12 15:29:06', '2018-10-13 03:29:06', null), ('5734fa3eae76286053f48c8a01d3c5b6', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-16 16:34:15', '2019-04-17 04:34:15', null), ('59261f2fa266a67a1b1255a0f0554379', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-05-09 11:18:23', '2019-05-09 23:18:23', null), ('59ecfc1f58c1e5f609d9228fffc84764', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 14:55:11', '2019-03-22 02:55:11', null), ('5c164840f73d374247ab7fd89c9d5bc0', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 14:47:12', '2019-03-22 02:47:12', null), ('5e11277c7ee7a7ff22871997c9c5082c', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-11 16:45:11', '2019-04-12 04:45:11', null), ('61b4699063d009a09a11f98da7f6444a', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-09 12:00:18', '2019-04-10 00:00:18', null), ('640773d807b4328edf3e60d7e2448e72', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-02-13 14:06:09', '2019-02-14 02:06:09', null), ('65b767723007f0dde5c43e51bad77815', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-02-15 17:31:01', '2019-02-16 05:31:01', null), ('6ae377875e267c271c796b917efde672', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-11 20:33:50', '2018-12-12 08:33:50', null), ('6ebff4687174438969d04ad775e28909', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-14 10:11:02', '2018-12-14 22:11:02', null), ('7bc7f56dc601ca87bc35ba2033bfa511', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-22 09:50:52', '2019-03-22 21:50:52', null), ('7cba40ea49fe7f5f1d909a2a3550a80a', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-17 09:22:13', '2018-12-17 21:22:13', null), ('7dafc85f787bbcceb1badb7a0ab21f9a', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 14:47:00', '2019-03-22 02:47:00', null), ('80ad91ec26e01915b44ae2ccb213f4cb', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-02-11 09:36:52', '2019-02-11 21:36:52', null), ('85bc9c4e7b512601616a0c06f5e9124f', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-08 10:52:39', '2019-04-08 22:52:39', null), ('8b7487087f564b5bd534a060c2bf6089', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-12 08:41:27', '2018-12-12 20:41:27', null), ('8cad82ec383d9bbbf06de10c920fba31', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-22 15:42:41', '2019-03-23 03:42:42', null), ('8e5c624ff8d9be9a94bedb83c974bf20', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-11 16:45:20', '2019-04-12 04:45:20', null), ('91c949d3760e52cb084e1b9af3973c7d', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-11 11:28:40', '2018-10-11 23:28:40', null), ('93a5256e340b8d0cc3c2cefbada24ad6', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-11 11:16:04', '2018-12-11 23:16:04', null), ('9600e602b163ca25e9b14bffdc3ced6f', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-22 15:43:33', '2019-03-23 03:43:33', null), ('99231a55fdd7ec4b81ceea003fe1c758', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-22 15:37:24', '2019-03-23 03:37:24', null), ('9a135344db92a5e1c88ceb333920780a', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 15:36:41', '2019-03-22 03:36:41', null), ('9a740f98edd9e1132c9330f657f7e1a4', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-16 14:36:18', '2019-03-17 02:36:18', null), ('9c9a831818aacf7717c58d2b4b902f3c', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-10 16:47:04', '2019-04-11 04:47:04', null), ('9eaf62f3eaf444874c66e0dfcb42b74d', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 14:08:36', '2019-03-22 02:08:36', null), ('a23dea9ba9e5949830c4ea7a3664f001', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-27 09:15:46', '2018-12-27 21:15:46', null), ('a50def036fbab8495d8e4fe5808a2849', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-13 10:41:49', '2018-12-13 22:41:49', null), ('a5f3b12387300fe2225f97195f0a691d', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-22 10:01:36', '2019-03-22 22:01:36', null), ('b18d05f1bf05183c940fa5f3622904b7', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-20 22:18:44', '2018-12-21 10:18:44', null), ('b47cddadcd8d73b169d31701c5b390ea', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-20 09:51:52', '2018-10-20 21:51:52', null), ('b754b4c832662b566958228329bc1cf5', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-08 11:29:04', '2018-10-08 23:29:04', null), ('bbd691ed0f4db44c3b61cd83c2736aa3', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-20 10:07:43', '2018-10-20 22:07:43', null), ('be772c64c27c15f3d7627c780087af30', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-28 10:14:09', '2018-12-28 22:14:09', null), ('c637f10596dc2a0de2e04b7eb9ca8444', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-16 15:23:56', '2018-10-17 03:23:56', null), ('c7dc838c6fa6866630debf972befaa30', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-15 16:33:48', '2018-10-16 04:33:48', null), ('cb2d19c39ad38a9fcc730c6b15217a88', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-05-10 14:47:34', '2019-05-11 02:47:34', null), ('d50d2a5e56e65048efeb526d89e982fb', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-19 09:31:54', '2018-12-19 21:31:54', null), ('d75ba5701d88e1adacc4ce736d43cd76', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 14:54:26', '2019-03-22 02:54:26', null), ('d8efeb85af017c5656726e03a2b36ce1', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-22 15:40:02', '2019-03-23 03:40:02', null), ('d9558cc8ee2fedb86b6a56a52b5048f0', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-26 09:45:40', '2018-12-26 21:45:40', null), ('dd6f4385042f134db13eae2413474f8a', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-04-11 16:44:55', '2019-04-12 04:44:55', null), ('f0b30a5ae6d3796eec95a097b9e4a5fe', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2019-03-21 17:10:48', '2019-03-22 05:10:48', null), ('f21a0eeeed35ec4a89cfc4ac8d71be6e', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-10 11:21:27', '2018-10-10 23:21:27', null), ('f35f9573381d0fa276c730477a531dfb', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-12 11:45:21', '2018-10-12 23:45:21', null), ('fd808277d1c3d929311783861bb02ec4', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-12-20 10:05:01', '2018-12-20 22:05:01', null), ('fd9ffa154f4c7ebba56f9cbaefe7a1bd', '0000000000000000000000000000000', 'admin', '伍邪', null, null, '2018-10-15 15:34:39', '2018-10-16 03:34:39', null);
COMMIT;

-- ----------------------------
-- Table structure for `oauth_user`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_user`;
CREATE TABLE `oauth_user` (
`user_id`  varchar(32) NOT NULL ,
`account`  varchar(32) NOT NULL COMMENT '登录帐户' ,
`user_pass`  varchar(256) NULL DEFAULT NULL ,
`user_name`  varchar(64) NULL DEFAULT NULL COMMENT '用户真名或昵称' ,
`sex`  char(1) NULL DEFAULT NULL COMMENT '用户性别：m男，w女' ,
`user_type`  int(11) NULL DEFAULT 1 COMMENT '用户类型，0管理员，1普通管理' ,
`birthday`  datetime NULL DEFAULT NULL ,
`phone`  varchar(20) NULL DEFAULT NULL ,
`email`  varchar(256) NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`last_login_time`  datetime NULL DEFAULT NULL COMMENT '最后登录时间' ,
`login_count`  int(11) NULL DEFAULT NULL COMMENT '登录次数' ,
`user_lock`  int(11) NULL DEFAULT 1 COMMENT '用户状态，0锁定，1解锁' ,
PRIMARY KEY (`user_id`),
UNIQUE INDEX `IDX_oauth_user_account` (`account`) USING BTREE 
)
ENGINE=InnoDB
COMMENT='授权用户'

;

-- ----------------------------
-- Records of oauth_user
-- ----------------------------
BEGIN;
INSERT INTO `oauth_user` VALUES ('0000000000000000000000000000000', 'admin', '123456', '伍邪', '1', '0', '2018-08-04 16:20:58', null, 'wuyy@xo68.com', null, null, null, null), ('2c9973d86dc64d538f31dd8717d8bc4c', 'wuyy', '123456', '伍邪', '1', '1', null, null, 'wyy@qq.com', null, null, null, null), ('93b1d0ec826a44f58d762ac9e467eacb', 'test', '111111', '222222', '1', '1', null, null, 'wyy@qq.com', '2019-04-11 15:16:00', null, null, '0'), ('cddf2e2eef3645bea303c784d76017f8', 'nnsword', '123456', '无名剑', '1', '1', null, null, 'wyy@qq.com', '2018-09-21 11:48:58', null, null, '0'), ('f237c75993a64e829b8c3d2978ae39fa', 'test2', '111111', '111111', '1', '1', null, null, 'wyy@qq.com', '2019-04-11 17:03:07', null, null, '0');
COMMIT;

-- ----------------------------
-- Table structure for `oauth_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_user_role`;
CREATE TABLE `oauth_user_role` (
`serial_id`  varchar(32) NOT NULL DEFAULT '' ,
`user_id`  varchar(32) NULL DEFAULT NULL ,
`role_id`  varchar(32) NULL DEFAULT NULL ,
`operator_name`  varchar(64) NULL DEFAULT NULL ,
`operator_id`  varchar(32) NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`serial_id`)
)
ENGINE=InnoDB
COMMENT='用户角色信息'

;

-- ----------------------------
-- Records of oauth_user_role
-- ----------------------------
BEGIN;
INSERT INTO `oauth_user_role` VALUES ('0a18a5d812f24c3b8abcbaa7afaecf87', 'f237c75993a64e829b8c3d2978ae39fa', '3571b34adad94c07888e5b84341fa862', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-11 17:03:07', '2019-04-11 17:03:07'), ('100cde1d58984e01abc923e3d4dd6dcb', '90a6c5eb61714930b96321c890b876f0', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-10 17:05:03', '2019-04-10 17:05:03'), ('102af8b4a25c4cbfa33948dbeaff5dc3', 'f710534cd69a4c808e84bcae78802eb3', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 15:13:00', '2018-09-21 15:13:00'), ('1bfce5395aa94b5d87971bfe0761bdfa', '0000000000000000000000000000000', '3571b34adad94c07888e5b84341fa862', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-05-09 14:09:20', '2019-05-09 14:09:20'), ('1c018b5f129f4ec488efcca24734fd2d', 'a2706d9c0d5c44d5a3c70b6af2a7fff5', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:37:26', '2018-09-21 11:37:26'), ('1ebd4e1dea884af385039489f17b0ec5', '0000000000000000000000000000000', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-05-09 14:09:20', '2019-05-09 14:09:20'), ('2ef1a42866b241fd9288e5732a95f4fe', 'cddf2e2eef3645bea303c784d76017f8', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:48:58', '2018-09-21 11:48:58'), ('49bba8a4cafe412e8410a33b56e4cbe5', '200a9028039242f5a8f63afe457c2537', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:17:46', '2018-09-21 11:17:46'), ('49e731106aa94d909d079a5804e60479', '2c9973d86dc64d538f31dd8717d8bc4c', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:17:56', '2018-09-21 11:17:56'), ('4b79b6cc538442f392ec29e00fc1a777', '90a6c5eb61714930b96321c890b876f0', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-10 17:05:03', '2019-04-10 17:05:03'), ('4bed532543e04a1e8217b7b292137841', '7f789be1068548369c98bbe0e10793fb', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:37:31', '2018-09-21 11:37:31'), ('514791cf2fed4c9a88ef0b9002dc04e6', '92c718f7e2db446680aa5a385af6542c', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:50:29', '2018-09-21 11:50:29'), ('5648238efeac4eba995721d1e0a4d527', 'f710534cd69a4c808e84bcae78802eb3', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 15:13:00', '2018-09-21 15:13:00'), ('59b055f02a9742acb58e4d062289dc2d', '47972d1980ac4a2bb8b54fa3fc182084', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-11 10:11:02', '2019-04-11 10:11:02'), ('5af779c19dba4cdba3d4d6eb9ac104b9', '0000000000000000000000000000000', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-05-09 14:09:20', '2019-05-09 14:09:20'), ('6e3fae9a63f94512ad9e26a5ceaece87', 'e45e474af38c4930b3c99612d76b85cc', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:37:19', '2018-09-21 11:37:19'), ('781d4a3c760b43c1a3b108702664addf', '93b1d0ec826a44f58d762ac9e467eacb', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-11 15:16:00', '2019-04-11 15:16:00'), ('7c31592bf1114efcb9dac6016d21cf0c', '200a9028039242f5a8f63afe457c2537', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:17:46', '2018-09-21 11:17:46'), ('7d60e71b7ed64b47bab5c30a64f0721c', 'a2706d9c0d5c44d5a3c70b6af2a7fff5', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:37:26', '2018-09-21 11:37:26'), ('934e8bec12724c6a9acd70f72ed62943', '0000000000000000000000000000000', '3571b34adad94c07888e5b84341fa862', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-05-09 14:09:18', '2019-05-09 14:09:18'), ('a07a9f5d65884f40b0d8dc8e12fe5317', '2c9973d86dc64d538f31dd8717d8bc4c', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:17:56', '2018-09-21 11:17:56'), ('a93337a6459f42b7ad189c63c00c2dca', '420a55c06dc048eaa7543433c339c1fa', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 10:53:29', '2018-09-21 10:53:29'), ('aa2ceda86ecc42b5b0d251c9674816b4', 'a5b0322c19db4f12984d7a120de46e57', '3571b34adad94c07888e5b84341fa862', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-10 16:59:34', '2019-04-10 16:59:34'), ('b054d6bea86c414ba42a148e2c60ab0a', '0000000000000000000000000000000', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-05-09 14:09:18', '2019-05-09 14:09:18'), ('b057c9389bf147869631f5e29889f5ee', '0d7f5cc99edf4647b8f3071cbdcc6a17', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-11 10:06:15', '2019-04-11 10:06:15'), ('b2721b7d91364d4ca31ac599aa61ac22', 'e45e474af38c4930b3c99612d76b85cc', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:37:19', '2018-09-21 11:37:19'), ('b6f2395f2a8745c4b04a633e6e265187', '420a55c06dc048eaa7543433c339c1fa', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 10:53:29', '2018-09-21 10:53:29'), ('b859ddfe8d3d49e4b251c2a16459f02d', '92c718f7e2db446680aa5a385af6542c', '5458f4113c344c74a80ab4a57815c6f0', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:50:29', '2018-09-21 11:50:29'), ('c8de87db3a354d4b83f8348a550f5cbb', 'cddf2e2eef3645bea303c784d76017f8', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:48:58', '2018-09-21 11:48:58'), ('cfb9ab5bd3c548f3808a7165f870c812', '90a6c5eb61714930b96321c890b876f0', '3571b34adad94c07888e5b84341fa862', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-04-10 17:05:03', '2019-04-10 17:05:03'), ('da190e4df4c84370816c4194186a24cb', '0000000000000000000000000000000', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2019-05-09 14:09:18', '2019-05-09 14:09:18'), ('fc948bc40626425c92647bbadb5e0fd3', '7f789be1068548369c98bbe0e10793fb', '496efc2f219d46f0935de14c46efacc1', '0000000000000000000000000000000', '0000000000000000000000000000000', '2018-09-21 11:37:31', '2018-09-21 11:37:31');
COMMIT;
